Tabela PatientTreatmentSteps

Definicja tabeli PatientTreatmentSteps

Name

PatientTreatmentSteps

Code

PatientTreatmentSteps

Comment

Tabela zawierajaca etapy leczenia dla pacjenta.


Lista kolumn tabeli PatientTreatmentSteps

Name

Code

PatientTreatmentStepsID

PatientTreatmentStepsID

TreatmentStepsID

TreatmentStepsID

ParentID

ParentID

PatientID

PatientID

StartDoctorID

StartDoctorID

StopDoctorID

StopDoctorID

StartDT

StartDT

StopDT

StopDT

Active

Active

Comments

Comments


Kolumna PatientTreatmentStepsID tabeli PatientTreatmentSteps

Definicja kolumny PatientTreatmentStepsID tabeli PatientTreatmentSteps

Name

PatientTreatmentStepsID

Code

PatientTreatmentStepsID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna TreatmentStepsID tabeli PatientTreatmentSteps

Definicja kolumny TreatmentStepsID tabeli PatientTreatmentSteps

Name

TreatmentStepsID

Code

TreatmentStepsID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ParentID tabeli PatientTreatmentSteps

Definicja kolumny ParentID tabeli PatientTreatmentSteps

Name

ParentID

Code

ParentID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PatientID tabeli PatientTreatmentSteps

Definicja kolumny PatientID tabeli PatientTreatmentSteps

Name

PatientID

Code

PatientID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID pacjenta


Kolumna StartDoctorID tabeli PatientTreatmentSteps

Definicja kolumny StartDoctorID tabeli PatientTreatmentSteps

Name

StartDoctorID

Code

StartDoctorID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID pacjenta


Kolumna StopDoctorID tabeli PatientTreatmentSteps

Definicja kolumny StopDoctorID tabeli PatientTreatmentSteps

Name

StopDoctorID

Code

StopDoctorID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID pacjenta


Kolumna StartDT tabeli PatientTreatmentSteps

Definicja kolumny StartDT tabeli PatientTreatmentSteps

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna StopDT tabeli PatientTreatmentSteps

Definicja kolumny StopDT tabeli PatientTreatmentSteps

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Active tabeli PatientTreatmentSteps

Definicja kolumny Active tabeli PatientTreatmentSteps

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

Yes

Comment

 


Kolumna Comments tabeli PatientTreatmentSteps

Definicja kolumny Comments tabeli PatientTreatmentSteps

Name

Comments

Code

Comments

Data Type

VARCHAR2(2000)

Mandatory

No

Comment

 


Lista kluczy tabeli PatientTreatmentSteps

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PatientTreatmentSteps

Definicja klucza Identifier_1 tabeli PatientTreatmentSteps

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment